Scott Orsey ✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	19

About Me

About Me

Industry	Healthcare
Area of Expertise	Operations
How I Use Smartsheet	Workflow improvements and data collection for collaborative activities

Analytics

127

Posts

164

Visits

555

Points

Dec 1, 2020

Join Date

Jun 21, 2024

Last Active

Reactions

• Insightful 8

  8
• Vote Up 26

  26
• Awesome 18

  18

• Activity
• Discussions7
• Comments120

• Re: How to use a formula to show the row # in a cell

  Scott Orsey

  03/28/24
  Hi @Sherry Fox and @Bert Hoffbeck , I've seen several options for doing this in the Community. The one I use is to go ahead and create an Auto Number column. I'll call it RowID. Then create a second …
  2 ·

• Re: Formula to list all projects that asked for additional funding and count number of times

  Scott Orsey

  04/04/24
  Hi @Edward Spencer, I like @Paul Newcome's suggestion of using the report approach with a dynamic chart, though I'm not certain that would exclude the zeros... I think the report would still calculat…
  1 ·

• Re: Formula to list all projects that asked for additional funding and count number of times

  Scott Orsey

  04/02/24
  Hi @Edward Spencer, You're close... you just have a parentheses in the wrong spot. See bolded... = INDEX(DISTINCT({2023 IAP Tracker ELT Approvals Range 5}), Index@row) Good luck
  1 ·

• Re: Is ther a way to format a cell so it only accepts a specific set of numbers and dashes.

  Scott Orsey

  04/02/24
  Hi @JimC518 , Sorry to say... nope. There aren't input masks for columns or forms.
  1 ·

• Re: Update cell in main row based on values in a group of rows?

  Scott Orsey

  04/02/24
  Hi @jmhoward , That certainly is a unique use case. The solution I suggested before would work better if you were always looking to report the "most advanced" status of all of the children.…
  1 ·

Next